<h1>Import robinhood data with the output plugin in MS Office</h1>

<p>In MS Office, in Data, Select Import->from text </p>

<img src="plugins/output/images/1.png">

<p>Use your URL instead of a local file, you can test your request with the console plugin</p>

<img src="plugins/output/images/2.png">

<p> Don't change anything (Delimited) , just click next </p>

<img src="plugins/output/images/3.png">

<p> Change to semi-colon , then lock on finish</p>

<img src="plugins/output/images/4.png">

<p> Select where you want to put the data </p>

<img src="plugins/output/images/5.png">

<p> In order to do a pivot table, select all your data and click on filter in data</p>

<img src="plugins/output/images/6.png">
<img src="plugins/output/images/7.png">

<p> To create the pivot table, in insert select pivot table</p>

<img src="plugins/output/images/8.png">

<p> let the default value to create the chart in a new sheet</p>

<img src="plugins/output/images/9.png">

<p> Select axis and value (ex. gid and sid) and you have the size usage by group </p>

<img src="plugins/output/images/10.png">

<img src="plugins/output/images/11.png">
